Dashboard

Column

Date

2020-11-24

Total Confirmed Cases

12513977

Mobility

67.82

Note

Tip: Data point values could be viewed when hover over visualizations.

Column

Motion Scatter Bubble Chart

Column

Confirmed Cases Map

Mobility Index Map

About

Row

Purpose

This dashboard application is developed to monitor mobility and COVID-19 development in the United States.

Date Sources

Johns Hopkins University, Descartes Labs, and U.S. Census Bureau

Row

Data Processing

  1. Extract/Aggregate values at the state level from each raw dataset;
  2. Integrate raw datasets into one master dataframe df;
  3. Subset master dataframe into a new dataframe for the most current date df_date;
  4. Transform master dataframe into another new dataframe at the monthly temporal unit df_m_avg

Data Visulization

  • Value Boxes: Total confirmed cases and mobility index on the latest date displayed
  • Motion Scatter Bubble Chart: Monthly average of total confirmed cases and mobility index by state since March 2020. Each bubble is a state colored by region and sized by population.
  • Choropleth Maps: Total confirmed cases and mobility index by state on the latest date displayed

Row

Programming Language, Libraries, and Tools

R, tidyverse, lubridate, plotly, flexdashboard, shinyapps

Contact

Feedback of the dashboard is welcomed. Please email author of this application at .